SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578038 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578038 [ RunTime:0.001973s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (142242,1037296,523143,258713,149767,559877,149924,589228,770582,37012,323213,443320,158179,153216,511577,28138,846520,1028830,868258,832109,622242,604858,414959,721610,997161,382538,1024764,590999,721208,421673,248708,72181,684834,781439,24857,288696,643541,58645,372586,577690,880254,281418,938424,978474,485625,51694,211506,507622,186602,481360,557004,17837,754613,807185,724893,910173,19659,566439,723150,410862) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001205s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578038 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578038 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]