SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001126s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013500 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013500 [ RunTime:0.003032s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892604,276668,924062,876985,488522,417024,457761,231068,795573,370477,283791,921753,381707,101860,241992,605462,276891,702345,971121,841442,11258,73125,438732,332336,447370,878841,881678,543694,108944,630594,620951,305777,312581,97340,191223,775291,448938,944086,370414,681122,181215,749799,498464,186774,183473,210274,904216,780721,305067,611889,1017933,422990,918240,645507,1014960,296953,717798,211469,136471,706891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002063s ]