SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001117s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312028 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312028 [ RunTime:0.003285s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (712548,684166,333342,114721,828061,1024894,854708,406687,293097,336620,294085,741168,601570,980717,899782,479085,655242,338036,13011,1028625,814548,790659,585394,29565,760996,212545,808767,385011,813908,911860,880620,820394,193121,540566,358356,600589,299270,111455,541455,405082,108525,610940,67263,872742,516309,893303,383204,271875,162397,256537,457487,93655,853555,130120,424118,918886,292978,553873,31747,1001356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000519s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000411s ]