SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505538 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505538 [ RunTime:0.001895s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (206589,965450,1030074,890779,529149,86707,70154,415272,455171,484189,375364,858425,379152,89220,331016,733721,996037,630778,541298,108923,300990,139058,216053,510180,9272,312159,410685,807725,668271,574307,874684,604320,625697,866772,634614,633630,323451,34761,620812,362899,806446,712106,824190,950712,913809,280231,253249,565762,633523,695225,946815,682233,271454,962884,271938,137591,479597,448971,205398,134685) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001191s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505538 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505538 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]