SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001444s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 134208 LIMIT 1 [ RunTime:0.001208s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 134208 [ RunTime:0.004790s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (555165,100289,400762,39829,656474,774227,99111,1032593,155227,174880,999351,417324,962078,925089,865178,245064,1018611,224260,504352,889243,689791,562948,4906,452104,116486,44686,682017,242935,959516,535879,448035,657654,192337,564112,172596,105168,652971,132594,828690,582561,19800,503473,217326,320422,150797,589237,986024,558176,819365,1018804,702082,787824,248051,601236,612374,775180,399578,352714,332362,49891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002923s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 134208 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 134208 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]