SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 584958 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 584958 [ RunTime:0.002579s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (792010,291607,266445,506029,515058,976452,115017,239171,395999,520600,86979,925657,587681,136179,331902,762955,232416,646565,985670,198847,184788,774134,209439,369814,824637,202469,783744,160762,278805,28729,420823,94601,805014,115484,38137,887747,368298,365962,809670,1009850,280036,727136,528352,284290,11162,502984,239894,820194,174828,894226,941869,365994,979991,1013859,168063,249129,312266,593528,309386,429175) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 584958 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000441s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 584958 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000612s ]