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` = 468423 LIMIT 1 [ RunTime:0.000317s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 468423 [ RunTime:0.002286s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (673611,540549,955434,793984,702569,535719,151090,300229,682276,698788,1033921,130255,559547,580493,232146,322690,281165,43702,945367,390793,899383,487410,688491,674714,321306,516252,207801,815209,977746,136084,860226,740389,67903,407439,539987,676365,754552,24963,26776,417176,673565,661680,812257,697224,771776,810684,1204,626488,1041544,481904,556168,908132,866103,400342,319232,168968,624314,636430,516145,747057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 468423 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 468423 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]