SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006040 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006040 [ RunTime:0.001513s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (839974,278231,567074,212245,609726,653873,869104,896722,340666,906621,353069,587278,1039269,396517,854583,955469,551927,942603,892014,860996,30696,105073,7097,696699,566031,630564,984515,374076,534709,428494,362010,286261,683877,247387,369873,705712,788118,798737,805388,869519,187282,780482,387162,1021909,522953,645527,918139,144429,677262,115917,42469,856176,477355,564064,1032689,891467,700406,1046463,240753,406164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006040 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006040 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000472s ]