SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 104412 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 104412 [ RunTime:0.002861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (869374,562198,197287,197609,257248,422333,651525,542344,737744,1001887,520565,450984,3360,601550,247119,655302,821984,15600,644723,650007,18856,276231,988659,1042179,1044388,516401,461946,531461,1007034,575914,733993,233779,68600,520312,14145,864086,981470,753978,724612,210272,14555,988924,123952,29046,587263,1047258,229271,543142,156424,278239,231214,624096,670683,642189,932057,778940,227519,250474,653969,131407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000986s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 104412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000338s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 104412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]