SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001250s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1027190 LIMIT 1 [ RunTime:0.000612s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1027190 [ RunTime:0.004283s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664784,1039894,372169,196778,843594,885220,27414,117574,177977,822812,871923,1010296,587614,1042803,426421,273,731875,21771,343386,707956,288583,420178,43733,130059,529545,608989,471782,790312,459723,790951,1012516,555263,361727,459214,598190,233915,784478,291132,226967,572582,602878,908007,872146,967367,120983,884367,443697,195137,261031,120732,532935,138064,503282,749143,698166,452643,790411,842961,124404,941474) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001724s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1027190 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001012s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1027190 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001324s ]