SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1023834 LIMIT 1 [ RunTime:0.000391s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1023834 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1026990,340783,636294,326418,812504,831454,846874,978318,294439,681543,156174,712148,128366,18009,896538,753188,660832,673813,974172,216646,177045,790945,115528,493433,994485,391360,661717,693212,125390,493586,716753,461523,711623,27800,751064,725416,4500,784123,497948,159005,315143,609342,775689,635615,810221,581859,456582,225837,475426,938299,279220,977396,230645,755909,233534,538766,968796,501842,839436,205783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1023834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000407s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1023834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]