SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578409 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578409 [ RunTime:0.006897s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (449086,900195,84224,793077,604641,180923,106933,946322,347250,917479,1004959,529706,189718,383496,455729,682419,118244,774461,935395,4033,663284,914580,38182,183071,1036072,248453,385956,446571,881446,723159,559008,598884,472158,386531,444869,100253,641927,402672,300891,34871,50933,836324,999259,124875,793788,307766,705909,255907,672352,950517,107735,307561,213333,340511,466529,1016013,63612,671151,980496,203152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001622s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000992s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000780s ]