SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 415483 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 415483 [ RunTime:0.002899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (131846,682411,304138,815781,1034694,79403,246543,898416,23968,287104,814545,409316,298809,381815,241605,1004711,630793,325072,104451,740101,354099,469520,661846,388613,1043701,526336,1006703,437066,251711,637593,1036397,989089,713611,145308,664134,963368,45088,212538,4885,717334,243149,564428,166666,981259,1002018,788930,368843,487685,933494,453947,501985,732822,705988,816264,233446,465182,716213,90159,516920,115180) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001167s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 415483 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 415483 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000439s ]