SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532089 LIMIT 1 [ RunTime:0.000905s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532089 [ RunTime:0.002754s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (399768,731971,611341,865968,823814,763248,301767,680471,479020,746331,633657,588015,319139,408457,929236,776906,398595,208631,313206,1007639,864129,102499,185379,638528,246096,86377,559285,930317,704269,484619,968321,1029202,1030059,409702,407056,645397,706223,359834,31676,454968,743918,238581,216396,910392,988720,855875,19219,199279,379247,703231,35284,544118,1021237,672059,855322,399176,401753,1040838,817784,154534) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001146s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532089 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532089 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]