SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44101 LIMIT 1 [ RunTime:0.000288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44101 [ RunTime:0.001562s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (414815,512013,75378,763448,76248,333972,512542,216751,904890,983052,514632,922567,835026,969946,951449,470319,379523,644053,683497,669663,862898,837859,598792,1028400,844116,517950,807147,427722,759621,458045,132741,374476,979014,79721,751039,590979,805109,618566,437030,813959,527507,891414,564362,862417,396655,679137,197785,820722,765841,655699,426348,358587,211066,838997,259633,873416,264777,1035937,604546,937392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001049s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000633s ]