SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305786 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305786 [ RunTime:0.002591s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (413128,554568,906553,613063,941987,642300,273097,440070,1027199,15437,172405,776713,318624,250622,969934,895976,597296,349673,199351,996864,72139,951720,988565,246172,330689,793866,846562,763283,114424,403004,661129,425387,592701,209449,188741,127844,413660,305556,175304,437004,805526,1035546,841545,989723,156783,614451,178068,598461,732612,674038,13672,1047518,132310,430894,657602,367015,481075,495736,200232,514107) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305786 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305786 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]