SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 436921 LIMIT 1 [ RunTime:0.000356s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 436921 [ RunTime:0.002212s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (528100,469678,199306,191315,170359,201243,632889,884093,481807,47123,778482,460609,279138,248213,415810,320056,947206,453582,195260,86376,897931,316329,634184,67404,42832,405414,604151,84388,139610,349163,232366,429533,411285,273933,82860,337174,103167,185562,384946,420105,183092,990235,848536,712363,1004042,523089,341362,21858,334970,869390,790347,298446,931792,398685,461737,68210,474477,523378,399445,177027) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 436921 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 436921 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]